package com.ruoyi.datastatistics.mapper;

import com.ruoyi.common.core.domain.Parameter;
import com.ruoyi.common.core.domain.Quaparameter;
import com.ruoyi.common.core.domain.entity.TPeaplegroupVO;
import com.ruoyi.common.core.domain.entity.TPeopleTypeVO;
import com.ruoyi.datastatistics.domain.Itemecountlist;
import com.ruoyi.datastatistics.domain.ItemevalutionVO;

import com.ruoyi.datastatistics.domain.ZhiBiaoXinXi;
import com.ruoyi.system.api.domain.SysDept;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ItemevalutionMapper {
    public ItemevalutionVO getItemevalution(Parameter parameter);
    @Select("select * from t_peopletype")
    List<TPeopleTypeVO> getAllList();

    @Select("select * from t_peaplegroup WHERE peapletypeid = #{id}")
    List<TPeaplegroupVO> getgroupList(int id );
    public int createdepts(Quaparameter parameter);

    public int createdeptspro(Quaparameter parameter);

    @Delete("DROP TEMPORARY TABLE IF EXISTS temp_depts")
    int Dropdepts();

    @Delete("DROP TEMPORARY TABLE IF EXISTS temp_stats")
    int Dropstats();
    @Select("select dept_id as deptId,parent_id as parentId,ancestors, dept_name as deptName,organizationcode,type from sys_dept where dept_id  = #{deptid} and status = 0")
    SysDept selectSysDept(@Param("deptid") Long deptid);
    public int createstats(Quaparameter parameter);

    List<Itemecountlist> getItemcountlist();
    List<ZhiBiaoXinXi> selectById(int maxId);

}
